Purpose of the project

We wanted to analyze airbnb data from ten major cities in the United States collected in 2019 to come up with a specific airbnb tourist guide that could give travelers more insights on which airbnb to choose and which host they could rely on.

Source of the data of the project

Source of data collected: http://insideairbnb.com/get-the-data.html

Summary

The data collected from the Seattle Airbnb dataset provides a good guide for accomodation in the city. In total, there are 5289 in the city. Although they are all welcoming, the neighbourhood that stands out with the most number of Airbnb listings is Broadway. The most popular type of property listed on Airbnb for this area is Apartment. The average price for accomodation in this area would be around 149.3243243 with an average rating of 94.2885772.

Aggregated chart

Here are the airbnbs hosts that have the top ten highest rating near Pike Place Market in 2019. These hosts have been verified as superhosts, have a 100% response rate, responses within an hour, and have their real identity verified through by Airbnb officials.

Host Name Item Name Host Ratings
John Gorgeous Downtown Condo Prime Location! 100
Ronny Downtown High-rise with Amazing Puget Sound View 100
Zeus Spacious Studio w/ Gym + Pet Friendly by Zeus 100
Jeff Pike Place Penthouse 99
Jessica Downtown Seattle Walker’s Paradise 99
David Pike Place Market Apt Water View and Balcony 99
Jackie Waterfront pikemarket view modern 2bdrm condo 99
Julia Kremrest - Garden Suite - Clubs, Bars, Restaurants 99
Jing King bed✫Cable✫Long-term in Downtown/Convention 99
Raj Waterfront Apt. with Spectacular Views 99
Ivar & Phoebe Best of the Best: Location, View, Amenities 99
Ezana ConvtnCntr/1BR, Close to Everything 98
Emma Visiting Spacious 1 BR Downtown & Capitol Hill 98
Gene Luxurious Pike Place 1 Bed Suite 98
David Cruise ships, Gumwall & Pike Place Downtown Suite! 98
Kyle & Giulio Spacious 2 Beds Waterfront Apt Near Pike Place Mkt 98

Interactive map

The reason why we wanted to use an interactive graph is because we wanted to show to location of each airbnb listing and the neccessary information tied to the listings, such as the house owner of the listing, price per night and room type, etc.

Bar Graph

This chart contains infomation of each neibourhood’s average aribnb price. It’s very helpful when people are planning their travel budget. You can search for housing result in different neigbourhoods based on your budget. The average airbnb price in Downtown is the most expensive in Seattle which is $288.4471 per night and Delridge is the least expensive with only $100.6805 per night.

Scatter Plot

This plot shows the number of listings for each neighbourhood. It gives a customer a good idea as to where popular listings are and good places to look at for accomadation.